Format Cross-Tab dialog box
This dialog box appears when you choose the Cross-Tab command from the Insert menu, or when you select an existing cross-tab and choose the Format Cross-Tab command from the Format or right-click menus.
Use the Format Cross-Tab dialog box to create a cross-tab quickly and easily. Cross-tabs are used in reports to present summarized data in a row/column structure, similar to that of a spreadsheet. These reports are easy to read, and they are particularly useful for making rapid comparisons and identifying trends.
The Format Cross-Tab dialog box makes it easy for you to set up sophisticated cross-tab reports in a hurry. To use this dialog box:
- Select the field(s) you want to use as column headings and place them in the Columns list.
- Select the field(s) you want to use as row headings and place them in the Rows list.
- Select the field that you want summarized and place it in the Summarized Field box. (A summarized field is the field that you want to displayed at the row/column intersections and totaled at the end of each row and at the bottom of each column.)
Note: In order to print a Cross-Tab report, you must enter at least one summarized field in the Format Cross-Tab dialog box. That is the only field required.
Related topics
Cross-Tab command